﻿CREATE TABLE [dbo].[ContaEmail] (
    [Id]            INT           IDENTITY (1, 1) NOT NULL,
    [DisplayName]   VARCHAR (255) NULL,
    [Email]         VARCHAR (200) NOT NULL,
	[Senha]			VARCHAR (300) NOT NULL,
    [SmtpHost]      VARCHAR (255) NOT NULL,
	[SmtpPort]		INT			  /*DEFAULT (0)*/ NOT NULL,
    [DataInclusao]  DATETIME      /*DEFAULT (getdate())*/ NOT NULL,
    [DataAlteracao] DATETIME      /*DEFAULT (getdate())*/ NOT NULL,
    [Ativo]         BIT           /*DEFAULT ('1')*/ NOT NULL,
    /*PRIMARY KEY CLUSTERED ([Id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)*/
);
